SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425328 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425328 [ RunTime:0.001612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39684,462817,839837,353548,905338,291614,510738,228916,194594,969200,499889,928689,6340,712837,237732,816959,255696,285533,252485,855287,279927,370459,954120,488143,266633,968280,1047219,214403,948035,511116,89292,9400,102668,816804,415894,48623,826609,695795,859747,576610,790444,24670,200483,488402,728878,335091,320170,814061,10325,849109,164175,407277,655035,317853,554503,994591,684372,469208,606379,635463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]