SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354403 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354403 [ RunTime:0.002161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103042,928178,503757,1014077,855572,123369,771732,401159,3395,850886,69529,643850,959976,927489,146851,215717,247380,497675,741599,174613,815274,905958,366077,901828,536474,678138,458196,854812,265832,133973,588677,804966,118185,770391,293452,1013585,402142,419040,458547,336674,834275,1016692,900354,60242,127528,474269,203327,765502,393511,358264,199294,955497,82827,1001083,907140,615943,20166,122056,895622,729615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]