SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438891 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438891 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850899,641391,538358,371114,917123,484689,341589,368981,543391,740579,996481,481540,128908,450037,703299,689893,481605,711166,382414,973781,997734,761349,621892,447834,590921,496099,147217,147588,106034,876605,162273,48433,167488,854968,356770,933071,544771,1036501,904274,306849,322404,700723,418877,471686,368490,396341,1035768,755838,969455,808091,58502,908961,472080,315427,582388,41977,1012292,413895,273915,113951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]