SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025518 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025518 [ RunTime:0.002586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939996,295323,622929,870636,963201,900416,371195,226424,747528,484725,453548,495067,965145,635701,670510,601445,360448,673677,770224,724830,611381,609738,87966,541902,591539,843316,190399,759100,551026,284733,639611,598916,295993,130187,628506,67257,297078,626244,383868,316975,967034,421790,116420,379583,293227,1002981,632798,195880,867459,1010455,421209,473200,1000424,397194,324245,152131,403690,199339,531750,379890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]