SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41807 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41807 [ RunTime:0.002183s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611397,232081,47323,854296,577182,616140,123322,327641,1048893,422727,666044,249750,99588,892753,473685,779554,535052,176960,336865,127462,144420,618211,487140,547814,82681,214396,863494,676461,295814,705877,730692,686689,579979,537977,684365,759122,52123,844046,324432,323192,21229,79709,897138,408340,359349,210690,815061,812354,404851,716261,598177,412617,1015830,802958,412166,407368,112236,783806,857675,211866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]