SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017769 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017769 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (913982,1014541,965205,45903,444522,156604,44429,431047,500992,184445,688817,614515,392650,634357,123572,648454,515861,521724,285959,581476,229976,624389,514390,397426,560725,873537,790090,376614,766201,93710,593640,713603,639616,556624,489630,653494,891192,957708,347261,203502,705655,934337,398908,19734,549214,813406,371337,842666,458019,1027544,481981,370288,214458,57143,910590,853458,456068,49900,931517,829855) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017769 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017769 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003919s ]