SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204658 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204658 [ RunTime:0.001373s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414937,516253,642027,367922,202146,139056,813958,850451,301393,348836,723421,699382,949246,426347,745053,78437,868983,503417,494801,205552,482991,57490,873193,866903,674978,686723,712998,55404,334614,498003,676869,223798,847199,1012243,803136,939096,859085,596502,656683,357528,946362,9439,332431,879072,801204,188032,553077,226104,477536,245657,1040316,111755,824290,398656,670657,437998,98202,394219,863808,357914) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204658 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204658 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]