SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417821 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417821 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989742,448050,623274,836405,983969,853723,701418,497516,1047268,226670,707295,724853,11565,356447,943793,49334,99898,391371,779719,210282,16753,604479,515,109246,478124,354982,498840,370101,772934,548829,211784,965018,963433,504249,124940,775971,646606,210424,39376,363130,338972,338720,423477,295186,362380,480451,646160,338982,413165,645222,686007,627536,817877,37378,710406,442224,879465,735186,705739,365916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]