SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34855 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34855 [ RunTime:0.001835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501281,717774,180610,29895,648872,44701,226164,513353,535260,865303,363990,635370,478000,572800,864371,394851,910883,809036,297540,552194,440655,673223,828923,810178,856871,211098,980416,263158,522422,462063,141032,888167,271662,275175,358124,693477,44745,98879,782954,1021772,330709,815106,649157,273815,1020248,580172,724478,827578,602558,851740,428398,96409,715797,413067,553984,46776,359963,714428,742763,464000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34855 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34855 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002127s ]