SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425412 LIMIT 1 [ RunTime:0.004377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425412 [ RunTime:0.005135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219525,259988,359080,725142,1022204,429240,552001,445912,944986,807489,599870,630806,321897,597961,202135,297839,461430,627504,770764,97357,592384,36692,560408,540737,346542,258193,933284,248444,439498,28842,945419,266577,62094,1036778,593799,711614,405186,792965,659721,496432,787576,361704,268574,947728,302638,810573,886984,680630,593758,784671,476151,696596,297727,676774,954140,689556,584864,312766,715549,651084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004797s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007441s ]