SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 17404 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 17404 [ RunTime:0.001448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544984,392241,436570,355210,409542,711389,816137,754672,618054,66331,617590,753482,1006014,800563,979696,787034,676983,446114,584604,696701,355849,557794,97228,738994,839303,250071,520858,1027687,399551,747908,75664,743095,812523,650152,700564,322511,909765,605113,649334,381538,294463,997864,850407,738447,70239,852604,710466,625559,146563,302002,800174,196214,422992,961686,737177,740743,750041,171370,292183,727965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 17404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 17404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001428s ]