SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101103 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101103 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172555,299458,888186,638498,312430,281507,944176,661009,831443,362075,482597,665091,695833,250844,490585,285796,452601,1035413,597320,527850,937011,496815,183292,363189,837472,306834,283804,651902,69880,125731,953234,1046250,613923,402487,527842,377198,363485,465100,503208,1036836,928212,826567,398580,145251,398449,617784,15060,514372,407171,277337,716660,265182,148083,330374,821310,850965,675251,918485,133235,214517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001478s ]