SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023249 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023249 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122034,600155,360269,45854,875198,610186,251159,93101,227590,503271,279172,884278,473798,660873,174006,751211,340746,132334,811116,547602,513936,940282,257044,1006234,562614,97661,214292,825954,407139,510823,302777,1000316,554851,975213,1013074,89841,465695,755373,730642,297504,692121,963931,245729,953802,309836,721440,410152,368218,818191,509893,46748,988660,113613,259521,216289,313464,495948,662747,387107,188045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023249 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023249 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]