SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429142 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429142 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289042,632674,605956,486622,663946,217058,371335,996826,448305,455220,652497,631629,284587,952297,870668,559470,251058,871359,849538,50572,426673,449444,374295,270617,837485,13985,521873,715040,493089,567331,433731,385368,41833,212535,9703,369841,1036080,603219,610703,941530,800582,573326,60454,638897,978179,292132,122692,443079,214708,511502,415005,376050,707155,905397,866099,194037,273230,724256,851940,904113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]