SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319117 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319117 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (824025,182770,324233,423621,366294,211105,183690,833482,790347,673244,379303,728214,534415,335495,307305,243915,577700,606450,980653,280039,717508,657817,234465,942972,535564,1007218,541860,623334,815232,850509,826185,593539,192343,183130,640399,951217,164070,10683,146552,724172,365107,629514,466646,698886,286454,167997,213670,853074,755293,831675,901066,365407,219737,727375,467089,539453,531117,669192,585245,608443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]