SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54113 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54113 [ RunTime:0.003021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791576,32510,115300,625884,671330,1022685,829975,563966,502323,555484,101753,786655,617413,733291,314347,1048341,997632,323915,117035,218987,886724,624085,532888,608573,315395,604268,529945,802160,542871,277014,807509,402665,229505,687851,567504,818347,69649,431564,395029,775105,601829,836332,1047723,425245,604758,472943,158061,767514,363793,299742,512821,1033642,149469,549467,892644,487498,609033,289740,885515,717825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]