SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41823 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41823 [ RunTime:0.002026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201478,94117,271050,905451,29715,415662,608808,370978,653619,391127,859211,805,526390,481270,409920,911269,718403,470440,801619,159332,235663,426461,264198,936016,750717,988346,503778,947341,744231,263837,965777,815726,798975,408068,1016824,265753,13335,345774,327976,151576,475848,168869,682631,456971,238180,383025,570577,295814,1037879,70403,430627,949492,346255,33471,194817,7876,827835,506436,867641,37035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]