SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107840 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107840 [ RunTime:0.002540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (762093,118832,283908,180982,85098,615912,517575,1019833,149424,477166,818450,403809,73785,260769,61130,245099,424746,580007,896251,128546,68321,108453,753949,185100,106513,792025,800075,219935,217105,447257,287381,459317,603328,377961,623229,591981,201601,484147,154515,107211,783997,898804,1004131,254048,721698,66227,674032,365694,986390,899863,372713,992820,582172,45467,599887,590245,909206,754720,753919,1000205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000784s ]