SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425285 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425285 [ RunTime:0.001873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734860,189524,342496,389050,199156,435096,499528,919430,96907,1003367,92758,726908,41622,716231,351773,39719,618992,236549,467872,567129,121012,565544,838136,136690,142981,795931,70746,351759,348131,108767,93152,681812,462277,287782,355243,112604,812398,739887,678169,306621,365042,1026827,319896,16965,909018,201567,569972,113770,146521,868133,964422,321973,636184,250430,325699,332013,692027,811126,886503,485034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000921s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425285 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425285 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]