SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292028 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292028 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968739,427162,654009,141530,297396,894830,1018703,256144,252449,844293,98893,772139,101324,934444,188641,130038,736271,596843,1043422,905034,281719,693873,354128,406375,879878,846384,858372,601598,1030375,656285,568894,854582,414076,735116,788151,184152,744877,878148,568319,798657,269615,854836,175877,348982,382823,366648,205826,337214,208511,970994,86164,501929,494622,996193,942882,620137,649757,513336,522048,366425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]