SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311610 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311610 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (244674,821076,1005659,60488,268673,45986,570495,886178,716233,712926,97143,191248,622696,23260,695011,8397,404378,147552,957319,949112,703282,444834,592187,816047,1008149,291691,234892,839106,733482,659677,1047453,129350,79628,430446,243810,462139,210065,34366,960145,452697,988678,850348,753068,35588,539673,5621,303847,424548,792659,22567,161336,264952,461566,225326,515960,664443,1033375,945708,442825,235521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]