SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394518 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394518 [ RunTime:0.003611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97934,587137,868523,664039,921632,306555,992577,349196,126763,761726,167527,191599,465554,216955,177937,889722,190649,535902,716880,463989,647751,983901,504089,402818,858113,847584,353557,322607,500243,52112,701223,885711,909769,14919,459133,704844,933370,421637,349259,559843,5536,780026,899566,101761,37263,305683,318170,631020,312554,557369,117989,518806,337264,305264,833584,2451,381751,925211,1037109,224405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]