SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356947 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356947 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106407,483097,658846,968538,360535,744166,494414,142635,146338,10192,685170,409199,547687,764397,227573,1037537,851114,133529,486839,140909,744699,490666,562448,726609,885707,641814,731058,569834,805609,257370,130574,321981,980351,532601,351807,350949,71311,391281,812586,646184,965594,466600,888008,766977,166476,330049,245735,914445,627750,285933,1012328,722875,250310,1026770,885453,689649,82655,35599,233049,741842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]