SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 378307 LIMIT 1 [ RunTime:0.000617s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 378307 [ RunTime:0.007033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (373843,851139,438245,136247,306200,968907,665501,509697,973581,941258,677580,1009878,823710,876460,298027,485614,719147,626741,559249,563476,1019099,1001252,1006354,285455,73119,946428,939575,352334,1014176,876741,350776,566166,940253,336080,178896,70846,292591,468324,680472,14991,504210,568154,61494,104756,549163,693120,567773,1034181,688329,357891,163873,463735,145836,340756,864035,871938,493432,809276,550692,387442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 378307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 378307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001431s ]