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` = 570246 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570246 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469330,343380,363983,272458,409753,640859,823157,436318,393813,308565,518030,124603,220899,248494,318280,866769,723146,372302,449450,480712,454827,718603,942305,503435,507892,93746,998292,825835,234675,376018,490248,679849,221968,1030461,652149,855173,756264,805469,858240,498293,1010961,742446,826039,384040,836667,195243,110570,482653,748811,632382,792971,634225,1005630,313632,125989,652623,706024,352674,38940,457570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002847s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003313s ]