SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002003s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543253 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543253 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039282,1002557,674136,688964,117823,155707,599017,352318,154789,703583,1010026,653596,1040104,441601,837872,583614,548918,810513,907072,681659,696736,125810,977120,63607,190763,495863,884081,663743,421965,184628,751743,381608,861424,77828,479067,499883,676023,487741,14731,533987,236232,938622,810338,743484,875293,211036,559856,938629,904462,815707,807844,306245,531905,21096,320188,765662,757426,92110,924337,82461) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000820s ]