SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 242448 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 242448 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847117,555361,97872,10662,213395,329103,154573,237407,349124,678375,334144,40077,642869,48604,14547,486669,920989,309578,757971,50020,198038,1004191,209910,951907,294052,690259,731355,215118,377987,826242,410569,232592,1006402,752124,658202,970879,863230,223130,309382,795163,291177,268102,820562,877061,493941,131912,613673,567425,31520,112624,288812,998635,815324,432826,339218,81878,2909,1029711,404824,349006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 242448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 242448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001136s ]