SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011224 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011224 [ RunTime:0.005606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509712,926725,933512,433519,789607,429093,404383,927464,230544,1003306,1042434,856981,1047983,1017769,838445,119075,869305,1004255,980644,933834,45950,55660,689568,353240,117951,782149,770731,504312,55608,380010,404602,1028240,535999,147803,511381,33110,857255,96826,669047,172870,1001154,139755,493829,944264,211712,4071,355724,507018,971385,895356,761321,135988,907619,656453,225325,812940,696865,155880,676939,764540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011224 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000627s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011224 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]