SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 321780 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 321780 [ RunTime:0.003028s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183403,1011214,657499,200257,254243,1035693,962489,258450,635198,780337,242843,358533,865691,956063,661107,849238,701240,911664,929434,881410,986873,668778,643063,281429,205666,820494,410777,291258,243876,808079,787608,622971,304106,632983,684043,208797,682097,938792,930322,309113,326656,1014900,674008,845495,1046739,1045380,735928,958035,286220,4448,693094,10733,938797,9231,317756,255922,755359,1044735,662268,285592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 321780 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 321780 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]