SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581098 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581098 [ RunTime:0.003259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470185,93960,461158,221375,115132,421679,64161,576538,34946,552907,431004,497660,916983,676935,1029798,832152,917923,868252,96709,598519,345911,30961,443226,24925,783293,362840,69521,149926,728188,906992,911599,1037563,216947,547989,639832,965983,118089,968596,863558,612197,536289,828641,801352,904953,41318,443839,838054,244862,466718,72842,639383,510337,672833,97714,520082,813168,348731,262398,1004575,234357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]