SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016488 LIMIT 1 [ RunTime:0.000696s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016488 [ RunTime:0.003018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315623,913138,635084,804154,82651,67066,902813,1017096,132747,7689,603121,410270,236074,11721,22517,135118,699009,393248,109284,69814,606983,544792,27443,498996,157669,586555,894561,493849,64130,265316,956887,489000,649586,407286,491941,192052,734063,179226,151828,139398,935555,852473,622888,238957,1000607,702651,1019969,977126,857821,985367,347879,518962,228332,301408,27098,1037126,236087,962050,205330,129290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016488 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000688s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016488 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]