SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5608 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5608 [ RunTime:0.003898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164864,225906,588018,438133,524669,636202,684934,555086,216065,244827,200866,537934,67045,361423,156200,686256,863058,141418,788153,773679,1035935,469913,842812,568566,115735,5211,818919,1014800,1018949,89996,684308,369979,858074,891910,68708,434207,322281,765116,689377,651893,299139,383983,277186,565383,23946,142098,210880,786450,881535,215338,1011621,293413,759682,691794,45591,740605,930534,327951,573834,574371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]