SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508533 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508533 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319099,820545,1041512,208305,742401,459423,478001,746214,1002620,916732,34402,549681,470422,58094,169329,444970,543341,384803,585962,394418,962305,36814,219879,995987,873471,30718,683121,975015,273199,1011184,58846,388038,601689,646358,377364,87741,159573,522013,698755,174526,88384,428001,817812,604819,938698,712826,269216,894924,179383,410405,31581,952364,435073,37541,519840,5465,225260,1035406,154687,200143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508533 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508533 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]