SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001925s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3103 LIMIT 1 [ RunTime:0.000504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3103 [ RunTime:0.002061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658845,925827,973287,889520,884404,787610,606298,9312,649539,420073,44158,396218,694007,692068,211934,854443,273041,842421,11392,1035919,820727,597534,355296,108717,272317,865342,267341,74554,503769,918642,240292,326709,969961,693129,560430,972987,571530,610300,897795,267257,164766,1001028,423829,678956,16326,1008150,753904,441135,901530,443106,388056,864680,550868,519346,386607,416786,1042167,948620,689569,901266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000760s ]