SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001427s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801038 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801038 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356971,898275,945085,90058,140080,10803,362725,661996,381489,632985,579933,630349,658774,141179,47286,1010273,534836,173832,1029453,992548,792644,745644,660909,409118,95573,934674,273586,202684,183158,39692,159243,528628,112070,562638,568397,410618,662111,865215,633843,510566,889691,1025631,863100,314932,979697,651577,1046286,725524,829809,1015975,879809,68083,182555,479651,908400,963117,490178,77478,532855,120734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001225s ]