SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31873 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31873 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7605,884785,144622,291579,1048146,572940,523069,1041129,357889,165269,265049,34815,917054,74461,992033,1045241,673259,445056,1043062,252923,468597,553334,300712,785107,834380,218670,1031935,15789,365773,17278,146115,361546,977837,712930,185064,961151,468450,519517,192881,144351,580268,671846,334047,438182,337850,452746,535921,350687,902651,929315,651631,830643,326656,685073,196082,237234,496482,55199,543046,528287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]