SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508130 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508130 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106913,862231,741311,587418,754876,47183,462857,636474,1409,1046864,330728,557025,31109,409581,79514,194581,261791,891826,245390,697478,605525,567984,614352,672457,1021147,935173,864687,801265,58208,503108,508903,314372,760928,765204,419919,534156,996001,672982,555152,366163,360172,1038683,602963,119308,307490,578414,989642,897402,971291,498969,67227,999785,197766,694764,80783,525383,839652,49431,607554,525692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508130 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508130 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]