SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504399 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504399 [ RunTime:0.002170s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385737,694431,369772,1047285,322935,181762,677134,32974,170709,619641,905351,315197,54390,225154,1031771,869885,526877,521980,683648,372464,893365,208759,773243,876979,362634,1027616,303557,1015940,116740,913467,751399,476435,546582,1015672,11947,79392,718702,572181,694461,1018824,398415,399029,468561,1014587,505605,940698,378172,671545,200041,863583,393630,759728,458670,311521,12046,708983,758465,289327,168569,419443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]