SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535449 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535449 [ RunTime:0.003847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483445,839958,410858,355753,646305,407878,535789,379595,587322,454776,633841,121038,709370,40241,672002,654388,987659,346644,465943,572399,101238,748652,837367,953943,299557,475099,117500,654243,797940,623377,154540,174074,627869,534965,104893,560716,137723,360006,895352,902640,627418,336996,348417,678049,845957,102123,7070,782520,385692,177726,412172,969888,641636,303122,62869,805989,155999,771442,306383,229653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000979s ]