SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043657 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043657 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672284,13697,552266,715162,358932,405137,124275,151544,925577,432612,529893,583017,460914,754491,814606,6901,131125,1003537,174050,698732,582058,905639,957647,279774,399910,772590,758841,221565,754012,1037381,727269,671001,679477,451978,464161,645965,854894,489304,765160,998871,508947,695876,167187,460483,735999,876397,706358,177620,678567,798173,272914,4550,424070,419539,258989,979983,1023848,270571,933340,773447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043657 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043657 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]