SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003777s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318120 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318120 [ RunTime:0.003199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (891102,705629,599140,142422,764751,1021366,440252,1041955,29543,461238,863782,463608,456417,200977,49161,457063,606289,314820,138040,590763,801966,374954,880319,539356,74740,524315,776322,630342,52503,709364,950711,118784,914748,522809,652741,640504,65675,900427,46812,250335,639101,986691,869461,227790,662805,453231,183520,999614,11178,892922,1048403,101480,418865,123319,982216,70948,190490,95038,412063,11069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001775s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]