SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002387s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52365 LIMIT 1 [ RunTime:0.000644s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52365 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289258,845717,221558,410830,159155,217214,101668,426129,201633,275556,173118,415368,453557,350061,763520,412990,223168,207219,1031631,291511,582352,713364,398654,725346,918213,684430,339379,334318,572574,697895,848828,245201,738385,694859,45630,7923,647560,71868,876928,752420,209548,974112,205901,935108,99814,738225,989355,41371,76019,716338,211411,292505,980366,903807,958028,494272,280319,296024,11633,1041089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52365 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52365 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]