SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110844 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110844 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920672,197568,275426,965937,54823,934911,496734,278034,899391,1048466,356951,671371,994925,286581,586986,466664,600125,877319,35695,270212,788171,185679,191674,35885,274588,893969,524830,458762,59751,311453,283779,992582,711450,486727,202841,874274,708622,116536,395878,885655,133972,994067,537306,291577,970539,704388,630826,975561,80632,109348,28945,135089,235785,958623,161003,553921,1040637,805887,670767,15594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]