SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581010 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581010 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (906751,218569,329292,175630,32516,86119,626481,410752,971065,4783,801317,740588,254934,371208,969334,945686,562922,69938,974476,1024302,63672,294344,778028,185092,768230,259577,926932,242392,591444,885275,940687,580991,726301,430100,378752,857153,936968,316576,490239,687201,191179,870509,166394,998137,699487,101797,625169,6958,433932,530419,202197,535236,212844,194909,297312,674225,13596,1025079,344892,42829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]