SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001653s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34543 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34543 [ RunTime:0.009725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367671,916490,225548,8991,792799,403401,554041,707489,834751,438624,871824,682467,373547,938629,151311,537783,894588,894197,552175,765381,871233,485845,449219,476662,1022920,648489,945281,10897,858010,526225,460278,926321,665661,580800,205850,531748,77771,190372,237875,346282,241605,641917,74218,948834,757274,959372,271253,521261,181027,686458,140976,711697,892642,930932,680666,781131,692663,911075,224051,668772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000729s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]