SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418313 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418313 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551905,612527,983437,16728,1012516,312401,344224,79504,1045643,131098,204501,484744,859420,539921,624860,274286,194281,807346,907723,440029,348987,180030,383660,663333,158771,730240,809798,566769,658164,542985,169720,260261,1025040,142802,534014,38717,534723,905537,852973,103420,118063,237952,349964,616595,193234,403430,147737,986533,663601,962631,798449,634383,549669,618378,693681,681478,342057,470867,122880,840735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]