SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 160711 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 160711 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (84980,485103,900272,1011797,914335,624997,545411,387,340818,12361,209072,860121,167006,1042220,734732,931248,44605,245895,499030,244194,217982,670621,336679,1046912,115949,489488,866554,835439,606734,528093,966219,892984,257297,1003990,751012,878740,607585,406894,524361,902050,625110,947462,193903,108022,993309,603585,160241,839701,724565,595539,1037031,490923,485032,926756,389094,989726,107823,828869,313043,5127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 160711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 160711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]