SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001643s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428099 LIMIT 1 [ RunTime:0.000571s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428099 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95138,507275,179772,64052,274047,714710,104573,484448,988584,641618,971003,89250,870370,226304,142908,659709,392801,615110,471927,732124,36013,195808,940996,1012057,333164,597569,808389,499346,600402,195960,81368,854328,96597,653194,860177,823379,629922,675994,782999,904960,943277,641760,386654,981260,231770,138712,68061,374230,578535,342397,644025,954072,35730,868844,707269,297610,519373,733014,434726,106026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]