SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565091 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565091 [ RunTime:0.001321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29492,673810,174207,191745,22220,989884,220845,80026,609448,437506,90055,556526,219725,385442,95407,703986,950418,847578,436339,393739,445190,951980,29193,849741,383622,781631,566791,1001370,935699,44878,820554,743562,259813,371695,523185,8290,448379,556595,1039192,275312,265944,282924,930507,196006,202854,923865,766491,700191,807529,371105,76840,99613,443588,18931,745288,1023517,740632,458467,212873,316521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]