SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003944s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422053 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422053 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381775,69510,820992,399123,387756,214148,811405,505554,913957,81814,719386,351709,645599,887050,1018789,842023,545728,276557,544148,827674,149701,356567,533071,1048370,133136,933986,910501,447696,645690,372606,770458,112088,1038445,541621,404681,18774,1043148,937682,291779,732032,771171,277866,155050,946419,418066,92154,287339,126613,892196,117687,768406,533569,26441,718420,13669,866244,397569,200960,297538,105268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]