SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456941 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456941 [ RunTime:0.001411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039072,657210,35996,828818,132317,180567,411987,434925,932319,805386,881421,771320,1003398,570178,274429,46811,1048146,701188,648527,704161,23062,697714,921753,851756,341193,6935,128828,274442,696442,319462,603681,580482,122115,742228,962312,796294,554352,374219,1009724,317181,405468,468936,354756,111771,475248,567357,471417,46982,491990,507478,598257,181895,981405,1004840,743698,263467,836883,882704,559836,656609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003805s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]