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` = 141210 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 141210 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101793,910145,394310,57088,195588,734132,675662,322524,667009,722082,555304,361777,747632,291405,385949,153855,62583,493525,98089,836807,44832,297375,15628,893662,328218,433864,896959,46717,596053,233156,203576,117138,412150,325659,697483,261381,824247,89603,125305,268078,868398,867704,425250,869270,190639,404876,656153,819507,1022704,549062,722036,937506,92751,319187,776979,487815,144873,948745,1044175,434629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 141210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 141210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]