SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 651241 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 651241 [ RunTime:0.002080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (590949,444304,933980,1017362,710739,878977,724753,1048619,40292,395759,980340,110814,490662,686092,561993,745013,731987,375468,722245,104911,1029389,194703,442651,922557,85942,16844,248342,201115,182519,331829,288995,322296,83300,481167,647822,315534,364144,483809,860114,12475,1045354,321506,517586,304316,890181,906741,260106,931113,157927,998939,640121,123760,953276,961941,483518,792835,77135,711259,904842,612758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 651241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 651241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]