SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538791 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538791 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826484,169048,726028,910667,739061,28515,905807,240494,363891,681939,1019804,753691,114801,699120,983506,610319,254104,274823,227075,860356,427406,393770,285039,842458,34880,660851,758461,121515,109192,652181,353774,227324,998542,991628,644859,376018,779530,233624,672036,1040251,508333,1014551,833894,467068,484031,988298,845902,1038873,586156,309959,758505,725183,874284,329009,22642,72686,336283,1019921,479152,720903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]