SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560079 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560079 [ RunTime:0.003224s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (898759,160379,997651,108470,473894,437352,1020736,73438,104470,962722,54402,336581,607380,143040,1029472,997345,24756,188005,130915,74501,478128,602971,217478,477445,674923,533161,144108,29229,43750,593104,799935,696963,147858,910193,1012519,351164,71998,585651,1037572,297040,269749,501251,42961,224586,987734,372951,103705,431470,404774,554252,867695,1037949,309333,578202,751394,886540,323289,318199,249806,347758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560079 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560079 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]