SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445202 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445202 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424169,133309,250714,141830,4959,901278,310721,526270,855974,712102,673869,735419,250343,699696,931910,1044286,192316,903080,334223,831061,697743,356659,33513,651082,765636,922286,196971,427236,255383,41909,873518,640997,891325,300957,546076,915912,289104,310993,515709,541949,1031052,876708,537668,800783,135629,146550,710363,531297,639950,794251,991582,836455,47500,281085,963333,356894,306030,285093,517437,823702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]