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` = 501289 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501289 [ RunTime:0.002796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (916834,12891,340910,910797,75038,465230,854786,293568,215345,524444,102241,162973,36233,1046365,650808,42051,977948,564011,125479,761172,346402,685586,122240,886158,205991,1014704,793821,505886,766949,189125,651150,1030964,58375,27741,761139,455007,713886,861969,343703,790697,904303,451720,547173,527122,125132,662411,486455,1027438,201594,121837,1040631,856248,797645,702237,95323,328145,486837,169276,988944,457113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000932s ]