SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50556 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50556 [ RunTime:0.003679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677727,983001,587430,65156,600702,206357,1036473,635637,702592,99154,370324,1011518,746880,135178,263205,442105,379669,732950,939129,599918,353219,299085,680693,517239,777537,1031930,1002246,168364,941699,787824,245059,164915,297284,90959,177036,943010,337498,751771,190641,632207,192602,497353,914982,10919,323172,31179,355088,208660,288121,530197,152445,405886,221576,131,557415,355617,433431,874814,317689,639721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50556 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50556 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000962s ]