SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44203 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44203 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752049,448656,492008,567487,798967,196803,426768,684119,142224,118334,963263,603099,848808,17563,980013,453800,223384,1043727,654231,622268,354761,291105,949215,638724,543415,410046,198758,433108,573975,220588,1017928,877882,491264,632030,990656,956909,695193,644214,94275,89186,316753,70148,49319,191569,981523,984259,580859,777792,838042,565277,983080,336449,483673,792808,622158,469186,677962,677835,194079,782295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]