SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002680s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 71213 LIMIT 1 [ RunTime:0.001929s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 71213 [ RunTime:0.002811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284438,82250,488413,1038567,624458,933228,431469,789060,374928,492743,283983,402577,851234,327369,551493,640875,377413,568665,935107,489639,44617,179586,986848,181398,724785,16433,703653,399768,648688,1048764,702035,544292,184852,819694,937322,234618,404357,557463,802753,459727,352563,198521,22189,493394,601548,693971,393999,509544,445331,643386,428895,64764,1027161,429324,161540,724115,742546,863411,178204,980512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 71213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 71213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]