SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464028 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464028 [ RunTime:0.001460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52067,333698,465307,931990,366441,673014,290654,120099,148669,694030,311835,695748,607662,159809,885304,375728,994038,813762,575994,98870,346545,917331,158034,479367,744254,862888,19097,423514,360605,818580,423405,512745,160281,594511,922364,593130,826624,311114,587615,712349,739539,999064,210903,631938,365883,744705,879154,584351,859035,78533,619952,921672,275312,945523,369752,474852,177879,459468,58401,670864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]