SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001504s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596652 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596652 [ RunTime:0.002133s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812343,172696,471790,697134,589525,918597,194480,449872,281595,559920,926729,320651,680756,10259,868980,17027,836186,188327,840413,15632,452835,963549,353050,262596,1007247,87030,609338,812581,272787,937150,820275,110633,60180,561408,598659,515485,898397,500277,673548,558808,140160,183808,603084,666619,796964,958188,186740,815500,99076,153230,733457,166775,536276,294592,224616,12791,505869,367519,1926,843036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003791s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596652 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000659s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596652 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]