SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53420 LIMIT 1 [ RunTime:0.001983s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53420 [ RunTime:0.005486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24733,1023654,638803,1040534,977935,191145,835838,1013908,258980,134613,164984,226210,650243,331410,641630,288130,515398,239260,92824,401931,923634,682064,557171,413103,506394,114094,906076,885393,165455,783773,967395,32398,127658,49022,942618,981068,421000,67542,538179,181424,797559,614814,629962,686932,511223,740262,532418,785827,79159,981118,533801,327899,426500,379292,335870,917268,932783,112130,465999,1015256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006866s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002687s ]