SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515203 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515203 [ RunTime:0.002050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415778,174184,338302,464645,471793,792486,797052,912111,127705,278671,155618,421804,936640,124714,75292,562548,507904,260914,167670,600251,634916,193314,869919,500147,839322,943210,697214,15054,777962,3018,902941,554452,769123,691976,59307,193259,891361,523288,349586,516161,215495,718672,747097,625497,773054,484776,558897,705074,429177,10692,395975,762527,395826,807452,352694,38832,23222,1030695,928236,35416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001793s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]