SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 125976 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 125976 [ RunTime:0.002005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508070,121023,387286,124401,107846,78507,182593,439651,509357,1003684,617003,371458,604472,727969,896997,118315,206733,526835,356919,606610,670037,854815,302905,422881,721356,365575,494211,461825,24826,103524,138482,459304,886216,935058,764475,1026010,816711,515516,598360,669690,104818,219660,230447,307343,253911,645668,37294,882618,308602,920053,748575,153630,262343,15772,356097,651938,405045,514027,194033,1038817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 125976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 125976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]