SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028832 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028832 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319159,203055,831085,909691,87260,518593,819923,880183,485496,134548,931594,1012185,28268,868954,886856,402747,231136,192930,968097,262701,124884,806182,284469,339370,1019660,720941,17087,731398,484374,932651,687231,746471,788608,728311,446772,1020490,487140,954063,117562,771789,586340,88936,835230,506325,40752,860759,886902,931753,545067,34296,485693,430781,293898,875028,319341,1010300,586964,598683,337187,932791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028832 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028832 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]